IF EXISTS (SELECT *
           FROM INFORMATION_SCHEMA.ROUTINES
           WHERE ROUTINE_NAME='pProduct_Delete'
           AND ROUTINE_SCHEMA='dbo'
           AND ROUTINE_TYPE='PROCEDURE'
          )
          DROP PROCEDURE dbo.pProduct_Delete
GO

CREATE PROC dbo.pProduct_Delete
	@id  AS INT
AS
BEGIN
	 UPDATE Product
	 SET IsDeleted = 1
	 WHERE Id = @id
END